CREATE TABLE `bed` (
  `bed_id` INT NOT NULL AUTO_INCREMENT,
  `bed_number` VARCHAR(55) NOT NULL,
  `bed_level` INT NULL,
  `remarks` VARCHAR(255) NULL,
  `status` INT NULL,
  `daily_rent` DECIMAL(10, 2) NULL,
  `monthly_rent` DECIMAL(10, 2) NULL,
  `yearly_rent` DECIMAL(10, 2) NULL,
  `created_on` INT NULL,
  `created_by` INT NULL,
  `timestamp` INT NULL,
  `updated_on` INT NULL,
  `room_id` INT NULL,
  PRIMARY KEY (`bed_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;